package com.example.mapper;

import com.example.pojo.OutMaterials;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface OutMaterialsMapper {
@Insert("insert into out1 (mname,num,price,time,total,note) values (#{mname},#{num},#{price},#{time},#{total},#{note})")
    void add(OutMaterials outMaterials);

    Long count(String mname, int num, LocalDate begin, LocalDate end);

    List<OutMaterials> page(Integer start, Integer pageSize, String mname, int num, LocalDate begin, LocalDate end);

    void delete(int[] id);
}
